import matplotlib.pyplot as plt
import pandas as pd
df = pd.read_excel('陈朝阳.xlsx', index_col=0)
plt.rcParams['font.sans-serif'] = 'SimHei'
x = df['总分']
plt.xlabel('姓名')
plt.ylabel('成绩')
plt.title('不同分数分布直方图')
plt.hist(x, bins=10, color=(0.894, 0, 0.498), edgecolor='k')
plt.show()